package com.yhao.stocknew.mapper;

import com.yhao.stocknew.entity.StockInfo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * <p>
 * 股票信息表 Mapper 接口
 * </p>
 *
 * @author yhao
 * @since 2023-12-15
 */
@Repository
public interface StockInfoMapper extends BaseMapper<StockInfo> {

    @Select("select * from stock_info where d_code not like '8%' and d_code not like '688%' and d_code not like '4%' and d_name not like 'ST%'")
    List<StockInfo> getAllInfos();

}
